

set more off

preserve

putexcel set tab1.xlsx, sheet(sheet1) replace

putexcel A1 = "Table 1:  Descriptive Statistics of Registered Voters of Sorsogon City"
putexcel A2 = "Panel A: Demographics"

putexcel A3 = "Variable"
putexcel B3 = "n"
putexcel C3 = "Mean"
putexcel D3 = "SD"
putexcel E3 = "min"
putexcel F3 = "max"

putexcel A5 = "Male = 1"
putexcel B5 = "81,202"
putexcel C5 = ".4865"
putexcel D5 = "0.50"
putexcel E5 = "0"
putexcel F5 = "1"

putexcel A6 = "Years of age"
putexcel B6 = "81,202"
putexcel C6 = "41"
putexcel D6 = "16"
putexcel E6 = "18"
putexcel F6 = "117"

putexcel A8 = "Panel B: Family name descriptive statistics"
putexcel A9 = "Number of unique family names: 14,491"
putexcel A10 = "Mean recurrence of family name: 11 (SD: 50 / Min: 1 / Max: 1571)"
putexcel A11 = "Herfindahl index: 99.85%"

putexcel A13 = "Panel C: Top 20 recurring family names"

putexcel A14 = "Family"
putexcel B14 = "Frequency of voters"
putexcel C14 = "Incumbent city official"

putexcel A15 = "name"
putexcel B15 = "bearing this name"
putexcel C15 = "bearing this name*"

putexcel A16 = "DIAZ"
putexcel A17 = "DIONEDA"
putexcel A18 = "DICHOSO"
putexcel A19 = "DIVINA"
putexcel A20 = "DETERA"
putexcel A21 = "DELLOSA"
putexcel A22 = "JEBULAN"  
putexcel A23 = "DOCTOR"
putexcel A24 = "DIESTA"
putexcel A25 = "JERESANO"
putexcel A26 = "JASARENO"
putexcel A27 = "JALMASCO"
putexcel A28 = "DEOCAREZA"
putexcel A29 = "JANORAS"
putexcel A30 = "DIMAANO"
putexcel A31 = "DIOQUINO"
putexcel A32 = "JANABAN"
putexcel A33 = "DOMETITA"
putexcel A34 = "LASALA"
putexcel A35 = "JAMISOLA"


putexcel B16 = "1751"  
putexcel B17 = "1569"
putexcel B18 = "1116"
putexcel B19 = "1069"
putexcel B20 = "932"
putexcel B21 = "888"
putexcel B22 = "866"
putexcel B23 = "840"
putexcel B24 = "830"
putexcel B25 = "798"
putexcel B26 = "774"
putexcel B27 = "730"
putexcel B28 = "718"
putexcel B29 = "702"
putexcel B30 = "688"
putexcel B31 = "686"
putexcel B32 = "673"
putexcel B33 = "666"
putexcel B34 = "631"
putexcel B35 = "620"

putexcel C16 = "1 Councilor"     
putexcel C17 = "Mayor / 1 Councilor"     
putexcel C18 = "Vice-Mayor"     
putexcel C19 = "1 Councilor"     
putexcel C20 = "---"     
putexcel C21 = "---"     
putexcel C22 = "1 Councilor"     
putexcel C23 = "---"     
putexcel C24 = "---"     
putexcel C25 = "---"     
putexcel C26 = "---"     
putexcel C27 = "---"     
putexcel C28 = "---"     
putexcel C29 = "---"     
putexcel C30 = "---"     
putexcel C31 = "---"     
putexcel C32 = "---"     
putexcel C33 = "---"     
putexcel C34 = "---"     
putexcel C35 = "2 Councilors"     


restore
